UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NC2vZnNzA8xM9uuaXk/A1FeuoXp2+EIMvihBOO7a1nI='
WHERE
key_id = 'd6d3b1d4c62d8df29a9db2295c8123e608bd1716e414ecd5b6d98577efef39cc'
AND (
token = 'NC2vZnNzA8xM9uuaXk/A1FeuoXp2+EIMvihBOO7a1nI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)