UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tz/+w9wf1+v2K2HbcaXcyuzf7e9d3L6QDgTUaNhE3Rc='
WHERE
key_id = 'b91b2d180874d4cc42e2141638f25264e976399fe89d2045fd9bd436b20bb9bf'
AND (
token = 'Tz/+w9wf1+v2K2HbcaXcyuzf7e9d3L6QDgTUaNhE3Rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)