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