UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DC75WhOl0e2fK+ycZHu5ud4aondoJfxur2M9YvLNpxM='
WHERE
key_id = 'cec9629050446c9f5d339b106e52695650732b8ea89ab2fa38a97bbd33211c28'
AND (
token = 'DC75WhOl0e2fK+ycZHu5ud4aondoJfxur2M9YvLNpxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)