UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AIOKSaQdo8RvSt/ThOK1HUV8TJqw/uPt3+xD5iwbhMU='
WHERE
key_id = '3dbbc9b53e49b4d12898a5d29272290761794b2edb6f7c3c45df244028ee4647'
AND (
token = 'AIOKSaQdo8RvSt/ThOK1HUV8TJqw/uPt3+xD5iwbhMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)