UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xVUVRDDx12PG/ZidsJCSE3WXsej8rTInCCxEoZbvZQQ='
WHERE
key_id = '4e66799fb38585c6d64c4cedbf7d95161e8079447afa01b525464c032e4cae97'
AND (
token = 'xVUVRDDx12PG/ZidsJCSE3WXsej8rTInCCxEoZbvZQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)