UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dN6O2hNWm9zsiWy+cTWJCdXq/sV00k+m0Yoz1IB5/lI='
WHERE
key_id = 'c1f0500097efffa3d33113c8d728684358ff775487b849c0df1eef7e9c8c2424'
AND (
token = 'dN6O2hNWm9zsiWy+cTWJCdXq/sV00k+m0Yoz1IB5/lI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)