UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zi8UrN8587So+Uv+3vXQ7oEzqGxPr+Z2LXLfD2Tm0ak='
WHERE
key_id = 'b59f420ac3d97bedf7953d904fe900768bf98460e1c1158a847ad85c228f5e2b'
AND (
token = 'Zi8UrN8587So+Uv+3vXQ7oEzqGxPr+Z2LXLfD2Tm0ak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)