UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm9mt4HYu0p65rky7Go3GBl4ItodKDxY4dPWIrXmBb5Q='
WHERE
key_id = 'b69c4b56a3be7f78e2d1bbf49e6c096a218ca7bbb384f6813171faec401fe5df'
AND (
token = 'm9mt4HYu0p65rky7Go3GBl4ItodKDxY4dPWIrXmBb5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)