UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/kjm3A0FuEtWPMgzCiQnot/XaFKBB81K/ewQw4MzGoo='
WHERE
key_id = '24dadb6ea3e7b2c407cd2ecd0ffbabecc7054f152ac3dbe697acc193bba9a25a'
AND (
token = '/kjm3A0FuEtWPMgzCiQnot/XaFKBB81K/ewQw4MzGoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)