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