UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SsJmrWZJxqvKWp2HnTYbcKcwA3KPiKLgeztiDGOiuF0='
WHERE
key_id = 'fb83e345b46cb6b1b4885c05cf73ed0a11b189141862e45b64e0f712a623e107'
AND (
token = 'SsJmrWZJxqvKWp2HnTYbcKcwA3KPiKLgeztiDGOiuF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)