UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pK5SD+3VjXB1avOuxGoy8thUrl3IFEI5goGAfhM5e6E='
WHERE
key_id = 'ab2a705677d72f67d096507984352888cf6ba4ed4de473f4fde807532cdc2acc'
AND (
token = 'pK5SD+3VjXB1avOuxGoy8thUrl3IFEI5goGAfhM5e6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)