UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HJwpRYOEOyEqKPdHfkZIPTb0qxor+0iD6G8655JTG10='
WHERE
key_id = 'e214be56ec1ce8b923d642928b0346c788ec589bffcc7e9a3abc5ddc99172cea'
AND (
token = 'HJwpRYOEOyEqKPdHfkZIPTb0qxor+0iD6G8655JTG10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)