UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qAhwISlk9LpzHpjmdIMzz9V7mp0RRVM/x2vd1q9lq50='
WHERE
key_id = 'd46c3b870302abb711ce6769c71074a025cfe91ef26e7699b78fbba902471127'
AND (
token = 'qAhwISlk9LpzHpjmdIMzz9V7mp0RRVM/x2vd1q9lq50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)