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