UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b4tjLBEBc7cAun1BcJCwcGKl9dLuo4eyr8G0I5UXyQU='
WHERE
key_id = '3169d92581cd9fbecef4648f522f97b8e247503f0f0e8fe36ae29a44830c7da0'
AND (
token = 'b4tjLBEBc7cAun1BcJCwcGKl9dLuo4eyr8G0I5UXyQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)