UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+gLlfQIWrD5Xa4TqosjTG8W8mE6sEHBwhuP6V4Bc6hg='
WHERE
key_id = '0737b9e650355d70acbf4fd6e5389579142d39fa36189fc2a4969fcdbb4b2bce'
AND (
token = '+gLlfQIWrD5Xa4TqosjTG8W8mE6sEHBwhuP6V4Bc6hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)