UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQp0u9hVaeJKoEU/8F7b/1yAlfd1XWqjxzIS3KhsbWo='
WHERE
key_id = 'a29146eaa4dab14df5385ce725475e3279899b414d13bea33c9aba91e5498238'
AND (
token = 'xQp0u9hVaeJKoEU/8F7b/1yAlfd1XWqjxzIS3KhsbWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)