UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nAekMSErPxk1hKRrIFhcTjOPk+A11TyDuTYlzDtlPHU='
WHERE
key_id = 'c37c68406daf8b01228302d6d39a069df8f2d0b38524a1815e491fa9f93eb5cc'
AND (
token = 'nAekMSErPxk1hKRrIFhcTjOPk+A11TyDuTYlzDtlPHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)