UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7bdQuhq8mI2cH6yMn6I01Xd0lF/wP7c3JNxK1AerfE='
WHERE
key_id = 'a5cc024205e06a047565429ab1c8c08e2fb29e342b01872a96624d50f8182360'
AND (
token = 'q7bdQuhq8mI2cH6yMn6I01Xd0lF/wP7c3JNxK1AerfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)