UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q57EO1NJZWa0ZfgvuKyovmtKTdqaaKrWflENaGmlYS4='
WHERE
key_id = '2b0ed97f0f8ef020d57f61f8e5d4f93765535d223b2dc5752e8eb6d98c6a720f'
AND (
token = 'Q57EO1NJZWa0ZfgvuKyovmtKTdqaaKrWflENaGmlYS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)