UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3j2gKcNcFUJY7jgfDrb6ip3MpdHpkyXJ4qUuOsY7t+A='
WHERE
key_id = '26cab257cd823d387543b9f3a23a81c597c927a442376098e7a19d64a0174523'
AND (
token = '3j2gKcNcFUJY7jgfDrb6ip3MpdHpkyXJ4qUuOsY7t+A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)