UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8kjpmpt+HzlUrXpABSiDtfAjouq4TyZZ/MOg0ql7RZ8='
WHERE
key_id = '67d9bbd2282ca845042ab4175afcb47731ad245376c7c91cf5478691159ec400'
AND (
token = '8kjpmpt+HzlUrXpABSiDtfAjouq4TyZZ/MOg0ql7RZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)