UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OcIlI1AtXbm7QZ4YclEKw/XWcv/Vpy8qtPeeHRb5ZIA='
WHERE
key_id = '4d24e26f7b4b516a3c3aa1d2a7f8e94c08c67e2327d87279f14e6965d46f2ec7'
AND (
token = 'OcIlI1AtXbm7QZ4YclEKw/XWcv/Vpy8qtPeeHRb5ZIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)