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