UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yp21jzXTMAkXo1Ic4stt2qTZq2SRZpeXh37joCV/BcM='
WHERE
key_id = '1e9d8efe60cbd3f776deef9bfc6ce15f0a2f331a69454796ff6732f02d6f8935'
AND (
token = 'Yp21jzXTMAkXo1Ic4stt2qTZq2SRZpeXh37joCV/BcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)