UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mpKIGVjYO5rePzYJELPbZ9PE13tgCCT4TyErQW2aEBA='
WHERE
key_id = '80d5feaaf28446da33eaf3a3f5e731834d6e398b156763f5361d23a5abec2306'
AND (
token = 'mpKIGVjYO5rePzYJELPbZ9PE13tgCCT4TyErQW2aEBA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)