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