UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4r3eAg93djzad43DW3bYP0XI6R0GlC8cgqA39eu7kco='
WHERE
key_id = '67fb7889e827eede932ae3b07902f1b566c48f45e8604eb6066e19cf92a742a1'
AND (
token = '4r3eAg93djzad43DW3bYP0XI6R0GlC8cgqA39eu7kco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)