UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NB5K+5i7tL+Fc0s5bn9rb0lfz3So7MyWNK3hKvkGpMM='
WHERE
key_id = '1814dcf55c38f11dd981782c5ebae11989940bfad936f77ffe65944306b11f72'
AND (
token = 'NB5K+5i7tL+Fc0s5bn9rb0lfz3So7MyWNK3hKvkGpMM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)