UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gId3cqHPUIDjGZ+ihWP6AzdwxQoh69ihsYlgS96TCI0='
WHERE
key_id = 'ccb79aa0521734e7c732fb12dda9c5892e9d0725f1eaa1f4c181b1a5e88a7f55'
AND (
token = 'gId3cqHPUIDjGZ+ihWP6AzdwxQoh69ihsYlgS96TCI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)